Missing Jobs Report

What is a Missing Jobs Report?

The Missing Jobs report provides a view of Collibra DQ jobs that were expected but didn't run on schedule.

You can generate a Missing Jobs report from the Reports page.

Steps

1. Sign in to the Collibra DQ instance and click the Reports icon in the left navigation pane.
   The Reports page opens.

2. From the Reports page, select the Missing Jobs Report link.

3. To configure the type of chart configuration and data you want to see in the chart, click the ellipsis icon.

4. Click Chart Configuration.
   The Chart Configuration window displays.

   Note As a best practice, keep the Chart Configuration as the default.

5. For x-axis, select one of the following options from the X-Axis Column dropdown list:
   • count
   • updt_ts

6. For y-axis, select one or more of the following options from the Y-Axis Columns dropdown list:

   • count
   • updt_ts

7. For the type of chart you want to display, select one of the following options from the Chart Type dropdown list:

   • Line
   • Area
   • Column
   • Scatter

8. Click Save.

9. Navigate the pages of your report by clicking the Previous and Next pagination buttons, located bottom-right of the columns.

Sample SQL query

You can use the following sample SQL query for a Missing Jobs report.

SELECT jsa.updt_ts::date AS updt_ts,
        jsa.dataset,
        bus.name AS business_unit,
        js.freq,
        js.active,
        js.mon,
        js.tue,
        js.wed,
        js.thu,
        js.fri,
        js.sat,
        js.sun
    FROM job_schedule_attempt jsa
    JOIN job_schedule js ON js.dataset::text = jsa.dataset::text
    LEFT JOIN dataset_scan ds ON ds.dataset::text = jsa.dataset::text AND ds.updt_ts::date = jsa.updt_ts::date
    LEFT JOIN business_unit_to_dataset bu ON jsa.dataset::text = bu.dataset::text
    LEFT JOIN business_units bus ON bus.id = bu.id
    WHERE ds.updt_ts IS NULL AND jsa.updt_ts >= (now() - '20 days'::interval)
    ORDER BY (jsa.updt_ts::date) DESC